Excel 2019 Macros and VBA: An Introduction to Excel Programming (Excel 2019 Mastery Book 4) by George Nathan

Author:George, Nathan [George, Nathan]
Language: eng
Format: epub
Published: 2019-12-11T16:00:00+00:00

VBA constants for the return value:

Constant

Value

Description

vbOK

1

The user clicked OK.

vbCancel

2

The user clicked Cancel.

vbAbort

3

The user clicked Abort.

vbRetry

4

The user clicked Retry.

vbIgnore

5

The user clicked Ignore.

vbYes

6

The user clicked Yes.

vbNo

7

The user clicked No.

The return value is the value returned when the user clicks a button on the message box. There are also VBA constants for the return values. For example, if the user clicked Cancel in the dialog box, instead of checking whether the return value is 2, you’ll check whether the return value is vbCancel . Using associated words rather than numbers makes them easier to remember.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.